Create Line and Clustered Chart for Total Accidents by Year, Month and Weekday 14
Our second chart is a line and clustered chart for the Total Accidents by year, month and weekday. Please follow detailed steps and format options shown below
Step 1: In the visualization pane, select the Line and stacked column chart. In the 'MyMeasures' Table, click 'AccidentsPerDay' and 'HighSeverityPerDay' as Column values. Drag and drop %YOYHighSeverity and %YOYAccidentsPerDay into the Line values. In The Date table, click on the Date dropdown to reveal the Date hierarchy, then click on 'Year' and 'Month' to the Shared axis. Finally, drag and drop 'DayofWeekName' to the shared axis.
Step 2: Format chart using the screenshots and GIF below as a guide
I. General
II. X axis and Y axis
III. Data Colors
IV. Data Labels